package com.medical.manage.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.medical.manage.domain.Advice;
import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

@Repository
public interface AdviceMapper extends BaseMapper<Advice> {

    @Select("select user.* ,area.area_name from user,area "+
            " where user.area_id = area.id and user.id = #{id}"
    )
    Advice getUserById(int id);


}
